<%@ LANGUAGE="VBScript" %> <% Set Connection = Server.CreateObject("ADODB.Connection") Connection.Mode = adModeRead Connection.Open phdb_rd SQLStmt = "select mt.HYBRID_NPOS,mt.WURST_ID,mt.CHANNEL,mt.SENSOR_POS,mt.SENSOR_ROW,mt.SENSOR_COLUMN " SQLStmt = SQLStmt & " from ASSEMBLY.MOD_MAP mt " SQLStmt = SQLStmt & " where mt.MOD_TYPE='" & Request("REQ_MOD_TYPE") & "' ORDER BY mt.HYBRID_NPOS,mt.WURST_ID,mt.CHANNEL " Set RS = Connection.Execute(SQLStmt) 'response.write(SQLStmt) %> Module Map

Module Connection Map for module <%=REQUEST("REQ_MOD_TYPE")%>

Notes:
Hybrid Position is 0 is for all Left hybrids as well as hybrids on Ring and Octagon Modules. Hybrid Position is 1 for all Right hybrids
Sensor Position corresponds to position of sensor in the module
Row and Column are calculated within the system of reference of the module

<% Do While Not RS.EOF %> <% RS.Movenext Loop %>

Hybrid Position

Wurst_ID

 Channel Sensor Position Row Column
<%=RS("HYBRID_NPOS")%> <%=RS("WURST_ID")%> <%=RS("CHANNEL")%> <%=RS("SENSOR_POS")%> <%=RS("SENSOR_ROW")%> <%=RS("SENSOR_COLUMN")%>
<% Connection.Close %>